package com.time.sky.mapper;

import com.time.sky.entity.Bank;
import com.time.sky.entity.Floor;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface FloorMapper {
    @Select("select * from floor f left join month m on f.mid=m.id left join dianl d on f.did=d.id left join water w on f.wid=w.id")
    List<Floor> queryFloor(Floor floor);
    @Insert("insert into floor (month,floor,money,total) values(#{month},#{floor},#{money})")
    void addFloor(Floor floor);
    @Select("select count(*) from floor")
    int getCount(Floor floor);
}
